
-- ----------------------------
-- Table structure for base_sys_conf
-- ----------------------------
DROP TABLE IF EXISTS `base_sys_conf`;
CREATE TABLE `base_sys_conf` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `cKey` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '配置键',
  `cValue` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '配置值',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `IDX_9be195d27767b4485417869c3a` (`cKey`) USING BTREE,
  KEY `IDX_905208f206a3ff9fd513421971` (`createTime`) USING BTREE,
  KEY `IDX_4c6f27f6ecefe51a5a196a047a` (`updateTime`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of base_sys_conf
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for base_sys_department
-- ----------------------------
DROP TABLE IF EXISTS `base_sys_department`;
CREATE TABLE `base_sys_department` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '部门名称',
  `parentId` bigint DEFAULT NULL COMMENT '上级部门ID',
  `orderNum` int NOT NULL DEFAULT '0' COMMENT '排序',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `IDX_be4c53cd671384fa588ca9470a` (`createTime`) USING BTREE,
  KEY `IDX_ca1473a793961ec55bc0c8d268` (`updateTime`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of base_sys_department
-- ----------------------------
BEGIN;
INSERT INTO `base_sys_department` VALUES (1, '2021-02-24 21:17:11.971397', '2023-03-07 00:39:53.000000', 'LVMX', NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for base_sys_log
-- ----------------------------
DROP TABLE IF EXISTS `base_sys_log`;
CREATE TABLE `base_sys_log` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `userId` bigint DEFAULT NULL COMMENT '用户ID',
  `ipAddr` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'ip地址',
  `params` json DEFAULT NULL COMMENT '参数',
  `action` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '行为',
  `ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'ip',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `IDX_51a2caeb5713efdfcb343a8772` (`userId`) USING BTREE,
  KEY `IDX_a03a27f75cf8d502b3060823e1` (`ipAddr`) USING BTREE,
  KEY `IDX_c9382b76219a1011f7b8e7bcd1` (`createTime`) USING BTREE,
  KEY `IDX_bfd44e885b470da43bcc39aaa7` (`updateTime`) USING BTREE,
  KEY `IDX_938f886fb40e163db174b7f6c3` (`action`) USING BTREE,
  KEY `IDX_24e18767659f8c7142580893f2` (`ip`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of base_sys_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for base_sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `base_sys_menu`;
CREATE TABLE `base_sys_menu` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `parentId` bigint DEFAULT NULL COMMENT '父菜单ID',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单名称',
  `router` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '菜单地址',
  `perms` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '权限标识',
  `type` tinyint NOT NULL DEFAULT '0' COMMENT '类型 0-目录 1-菜单 2-按钮',
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '图标',
  `orderNum` int NOT NULL DEFAULT '0' COMMENT '排序',
  `viewPath` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '视图地址',
  `keepAlive` tinyint NOT NULL DEFAULT '1' COMMENT '路由缓存',
  `isShow` tinyint NOT NULL DEFAULT '1' COMMENT '是否显示',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `IDX_05e3d6a56604771a6da47ebf8e` (`createTime`) USING BTREE,
  KEY `IDX_d5203f18daaf7c3fe0ab34497f` (`updateTime`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of base_sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `base_sys_menu` VALUES (1, '2023-04-26 22:46:59.754000', '2023-04-26 22:47:11.516379', NULL, 'Dashboard', NULL, NULL, 0, 'icon-workbench', 1, NULL, 1, 1);
INSERT INTO `base_sys_menu` VALUES (2, '2023-04-26 22:46:59.754000', '2023-04-26 22:47:11.516379', NULL, '系统管理', '/sys', NULL, 0, 'icon-system', 2, NULL, 1, 1);
INSERT INTO `base_sys_menu` VALUES (3, '2023-04-26 22:46:59.754000', '2023-04-26 22:47:11.516379', 2, '菜单列表', '/sys/menu', NULL, 1, 'icon-menu', 1, 'cool/modules/base/views/menu.vue', 1, 1);
INSERT INTO `base_sys_menu` VALUES (4, '2023-04-26 22:46:59.754000', '2023-04-26 22:47:11.516379', 2, '用户列表', '/sys/user', NULL, 1, 'icon-user', 2, 'modules/base/views/user/index.vue', 1, 1);
INSERT INTO `base_sys_menu` VALUES (5, '2023-04-26 22:46:59.754000', '2023-04-26 22:47:11.516379', 2, '角色列表', '/sys/role', NULL, 1, 'icon-dept', 3, 'cool/modules/base/views/role.vue', 1, 1);
INSERT INTO `base_sys_menu` VALUES (6, '2023-04-26 22:46:59.754000', '2023-04-26 22:47:11.516379', 3, '新增', NULL, 'base:sys:menu:add', 2, NULL, 1, NULL, 0, 1);
INSERT INTO `base_sys_menu` VALUES (7, '2023-04-26 22:46:59.754000', '2023-04-26 22:47:11.516379', 3, '删除', NULL, 'base:sys:menu:delete', 2, NULL, 2, NULL, 0, 1);
INSERT INTO `base_sys_menu` VALUES (8, '2023-04-26 22:46:59.754000', '2023-04-26 22:56:28.549542', 3, '编辑', NULL, 'base:sys:menu:info,base:sys:menu:update', 2, NULL, 3, NULL, 0, 1);
INSERT INTO `base_sys_menu` VALUES (9, '2023-04-26 22:46:59.754000', '2023-04-26 22:47:11.516379', 3, '查询', NULL, 'base:sys:menu:page,base:sys:menu:list,base:sys:menu:info', 2, NULL, 4, NULL, 0, 1);
INSERT INTO `base_sys_menu` VALUES (10, '2023-04-26 22:46:59.754000', '2023-04-26 22:56:28.560250', 4, '新增', NULL, 'base:sys:user:add', 2, NULL, 1, NULL, 0, 1);
INSERT INTO `base_sys_menu` VALUES (11, '2023-04-26 22:46:59.754000', '2023-04-26 22:56:28.562308', 4, '删除', NULL, 'base:sys:user:delete', 2, NULL, 2, NULL, 0, 1);
INSERT INTO `base_sys_menu` VALUES (12, '2023-04-26 22:46:59.754000', '2023-04-26 22:56:28.564287', 4, '修改', NULL, 'base:sys:user:update', 2, NULL, 3, NULL, 0, 1);
INSERT INTO `base_sys_menu` VALUES (13, '2023-04-26 22:46:59.754000', '2023-04-26 22:56:28.566051', 4, '查询', NULL, 'base:sys:user:page,base:sys:user:list,base:sys:user:info', 2, NULL, 4, NULL, 0, 1);
INSERT INTO `base_sys_menu` VALUES (14, '2023-04-26 22:46:59.754000', '2023-04-26 22:47:11.516379', 5, '新增', NULL, 'base:sys:role:add', 2, NULL, 1, NULL, 0, 1);
INSERT INTO `base_sys_menu` VALUES (15,'2023-04-26 22:46:59.754000', '2023-04-26 22:47:11.516379', 5, '删除', NULL, 'base:sys:role:delete', 2, NULL, 2, NULL, 0, 1);
INSERT INTO `base_sys_menu` VALUES (16, '2023-04-26 22:46:59.754000', '2023-04-26 22:47:11.516379', 5, '修改', NULL, 'base:sys:role:update', 2, NULL, 3, NULL, 0, 1);
INSERT INTO `base_sys_menu` VALUES (17, '2023-04-26 22:46:59.754000', '2023-04-26 22:47:11.516379', 5, '查询', NULL, 'base:sys:role:page,base:sys:role:list,base:sys:role:info', 2, NULL, 4, NULL, 0, 1);
COMMIT;

-- ----------------------------
-- Table structure for base_sys_param
-- ----------------------------
DROP TABLE IF EXISTS `base_sys_param`;
CREATE TABLE `base_sys_param` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `keyName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '键位',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
  `data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '数据',
  `dataType` tinyint NOT NULL DEFAULT '0' COMMENT '数据类型 0:字符串 1：数组 2：键值对',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `IDX_cf19b5e52d8c71caa9c4534454` (`keyName`) USING BTREE,
  KEY `IDX_7bcb57371b481d8e2d66ddeaea` (`createTime`) USING BTREE,
  KEY `IDX_479122e3bf464112f7a7253dac` (`updateTime`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of base_sys_param
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for base_sys_role
-- ----------------------------
DROP TABLE IF EXISTS `base_sys_role`;
CREATE TABLE `base_sys_role` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `userId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户ID',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
  `label` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '角色标签',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `relevance` int NOT NULL DEFAULT '1' COMMENT '数据权限是否关联上下级',
  `menuIdList` json NOT NULL COMMENT '菜单权限',
  `departmentIdList` json NOT NULL COMMENT '部门权限',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `IDX_469d49a5998170e9550cf113da` (`name`) USING BTREE,
  UNIQUE KEY `IDX_f3f24fbbccf00192b076e549a7` (`label`) USING BTREE,
  KEY `IDX_6f01184441dec49207b41bfd92` (`createTime`) USING BTREE,
  KEY `IDX_d64ca209f3fc52128d9b20e97b` (`updateTime`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of base_sys_role
-- ----------------------------
BEGIN;
INSERT INTO `base_sys_role` VALUES (1, '2021-02-24 21:18:39.682358', '2021-02-24 21:18:39.682358', '1', '超管', 'admin', '最高权限的角色', 1, 'null', 'null');
INSERT INTO `base_sys_role` VALUES (2, '2021-02-24 21:18:39.682358', '2021-02-24 21:18:39.682358', '1', '测试1', 'test1', 'test1', 1, 'null', 'null');
INSERT INTO `base_sys_role` VALUES (3, '2021-02-24 21:18:39.682358', '2021-02-24 21:18:39.682358', '1', '测试2', 'test2', 'test2', 1, 'null', 'null');
INSERT INTO `base_sys_role` VALUES (4, '2021-02-24 21:18:39.682358', '2021-02-24 21:18:39.682358', '1', '测试3', 'test3', 'test3', 1, 'null', 'null');
INSERT INTO `base_sys_role` VALUES (5, '2021-02-24 21:18:39.682358', '2021-02-24 21:18:39.682358', '1', '测试4', 'test4', 'test4', 1, 'null', 'null');
INSERT INTO `base_sys_role` VALUES (6, '2021-02-24 21:18:39.682358', '2021-02-24 21:18:39.682358', '1', '测试5', 'test5', 'test5', 1, 'null', 'null');
INSERT INTO `base_sys_role` VALUES (7, '2021-02-24 21:18:39.682358', '2021-02-24 21:18:39.682358', '1', '测试6', 'test6', 'test6', 1, 'null', 'null');
INSERT INTO `base_sys_role` VALUES (8, '2021-02-24 21:18:39.682358', '2021-02-24 21:18:39.682358', '1', '测试7', 'test7', 'test7', 1, 'null', 'null');
INSERT INTO `base_sys_role` VALUES (9, '2021-02-24 21:18:39.682358', '2021-02-24 21:18:39.682358', '1', '测试8', 'test8', 'test8', 1, 'null', 'null');
INSERT INTO `base_sys_role` VALUES (10, '2021-02-24 21:18:39.682358', '2021-02-24 21:18:39.682358', '1', '测试9', 'test9', 'test9', 1, 'null', 'null');
INSERT INTO `base_sys_role` VALUES (11, '2021-02-24 21:18:39.682358', '2021-02-24 21:18:39.682358', '1', '测试10', 'test10', 'test10', 1, 'null', 'null');
INSERT INTO `base_sys_role` VALUES (12, '2021-02-24 21:18:39.682358', '2021-02-24 21:18:39.682358', '1', '测试11', 'test11', 'test11', 1, 'null', 'null');
INSERT INTO `base_sys_role` VALUES (13, '2021-02-24 21:18:39.682358', '2021-02-24 21:18:39.682358', '1', '测试12', 'test12', 'test12', 1, 'null', 'null');
INSERT INTO `base_sys_role` VALUES (14, '2021-02-24 21:18:39.682358', '2021-02-24 21:18:39.682358', '1', '测试13', 'test13', 'test13', 1, 'null', 'null');
INSERT INTO `base_sys_role` VALUES (15, '2021-02-24 21:18:39.682358', '2021-02-24 21:18:39.682358', '1', '测试14', 'test14', 'test14', 1, 'null', 'null');
INSERT INTO `base_sys_role` VALUES (16, '2021-02-24 21:18:39.682358', '2021-02-24 21:18:39.682358', '1', '测试15', 'test15', 'test15', 1, 'null', 'null');
INSERT INTO `base_sys_role` VALUES (17, '2021-02-24 21:18:39.682358', '2021-02-24 21:18:39.682358', '1', '测试16', 'test16', 'test16', 1, 'null', 'null');
INSERT INTO `base_sys_role` VALUES (18, '2021-02-24 21:18:39.682358', '2021-02-24 21:18:39.682358', '1', '测试17', 'test17', 'test17', 1, 'null', 'null');
INSERT INTO `base_sys_role` VALUES (19, '2021-02-24 21:18:39.682358', '2021-02-24 21:18:39.682358', '1', '测试18', 'test18', 'test18', 1, 'null', 'null');
INSERT INTO `base_sys_role` VALUES (20, '2021-02-24 21:18:39.682358', '2021-02-24 21:18:39.682358', '1', '测试19', 'test19', 'test19', 1, 'null', 'null');
INSERT INTO `base_sys_role` VALUES (21, '2021-02-24 21:18:39.682358', '2021-02-24 21:18:39.682358', '1', '测试20', 'test20', 'test20', 1, 'null', 'null');
INSERT INTO `base_sys_role` VALUES (22, '2021-02-24 21:18:39.682358', '2021-02-24 21:18:39.682358', '1', '测试21', 'test21', 'test21', 1, 'null', 'null');
INSERT INTO `base_sys_role` VALUES (23, '2021-02-24 21:18:39.682358', '2021-02-24 21:18:39.682358', '1', '测试22', 'test22', 'test22', 1, 'null', 'null');
INSERT INTO `base_sys_role` VALUES (24, '2021-02-24 21:18:39.682358', '2021-02-24 21:18:39.682358', '1', '测试23', 'test23', 'test23', 1, 'null', 'null');
COMMIT;

-- ----------------------------
-- Table structure for base_sys_role_department
-- ----------------------------
DROP TABLE IF EXISTS `base_sys_role_department`;
CREATE TABLE `base_sys_role_department` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `roleId` bigint NOT NULL COMMENT '角色ID',
  `departmentId` bigint NOT NULL COMMENT '部门ID',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `IDX_e881a66f7cce83ba431cf20194` (`createTime`) USING BTREE,
  KEY `IDX_cbf48031efee5d0de262965e53` (`updateTime`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of base_sys_role_department
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for base_sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `base_sys_role_menu`;
CREATE TABLE `base_sys_role_menu` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `roleId` bigint NOT NULL COMMENT '角色ID',
  `menuId` bigint NOT NULL COMMENT '菜单ID',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `IDX_3641f81d4201c524a57ce2aa54` (`createTime`) USING BTREE,
  KEY `IDX_f860298298b26e7a697be36e5b` (`updateTime`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of base_sys_role_menu
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for base_sys_user
-- ----------------------------
DROP TABLE IF EXISTS `base_sys_user`;
CREATE TABLE `base_sys_user` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `departmentId` bigint DEFAULT NULL COMMENT '部门ID',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '姓名',
  `username` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户名',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密码',
  `passwordV` int NOT NULL DEFAULT '1' COMMENT '密码版本, 作用是改完密码，让原来的token失效',
  `nickName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '昵称',
  `headImg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '头像',
  `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '手机',
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '邮箱',
  `status` tinyint NOT NULL DEFAULT '1' COMMENT '状态 0:禁用 1：启用',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `socketId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'socketId',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `IDX_469ad55973f5b98930f6ad627b` (`username`) USING BTREE,
  KEY `IDX_0cf944da378d70a94f5fefd803` (`departmentId`) USING BTREE,
  KEY `IDX_9ec6d7ac6337eafb070e4881a8` (`phone`) USING BTREE,
  KEY `IDX_ca8611d15a63d52aa4e292e46a` (`createTime`) USING BTREE,
  KEY `IDX_a0f2f19cee18445998ece93ddd` (`updateTime`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of base_sys_user
-- ----------------------------
BEGIN;
INSERT INTO `base_sys_user` VALUES (1, '2021-02-24 21:16:41.525157', '2023-03-08 15:11:51.000000', 1, '超级管理员', 'admin', 'e10adc3949ba59abbe56e057f20f883e', 7, '管理员', 'https://show.cool-admin.com/api/public/uploads/20230308/c731b0cba84046268b10edbbcf36f948_315c243a448e1369fa145c5ea3f020da.gif', '18000000000', 'team@cool-js.com', 1, '拥有最高权限的用户', NULL);
COMMIT;

-- ----------------------------
-- Table structure for base_sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `base_sys_user_role`;
CREATE TABLE `base_sys_user_role` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `userId` bigint NOT NULL COMMENT '用户ID',
  `roleId` bigint NOT NULL COMMENT '角色ID',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `IDX_fa9555e03e42fce748c9046b1c` (`createTime`) USING BTREE,
  KEY `IDX_3e36c0d2b1a4c659c6b4fc64b3` (`updateTime`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of base_sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `base_sys_user_role` VALUES (1, '2021-02-24 22:03:11.665805', '2021-02-24 22:03:11.665805', 1, 1);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
